Run Data for specific date and use that date for calculations

[Anonymous]

Hey Community,

New to Power Bi and have been playing around for a month or so with it.

I was wondering if there is a way to use a specific date to filter and run data for. Like in excel I can have a date in one cell which I can change/select and all the calculations, and the data gathered is for that date.

I want to use that date for "if statements" and other formulas, would like a box/date table similar to the following to diaplay on the dashboard

Thoughts??

Cheers

[v-shex-msft]

HI @Anonymous ,

You can try to add slicer with data fields, then you can use slicer to filter your visual data based on selected date values.

Slicers in Power BI

Regards,

Xiaoxin Sheng

[Anonymous]

Hey @v-shex-msft,

Using the Slicer for the filter on the page is that I am familiar with. What about adding it into the table calculations.

Such as if I have a table which uses IF statement - IF(entered date<today(),x,y) I want to have a cell where I can input that "entered date" on the dashboard and run the file after that.

Let me know if I am not clear enough.

Cheers.

[v-shex-msft · Accepted solution]

Hi @Anonymous ,

So you means you want to get selected value from slicer/filter, right? If this is a case, I'd like to suggest you to use selectedvalue, allselected functions to get selection items.(they will effect by current filter effect)

Using the SELECTEDVALUE function in DAX

The definitive guide to ALLSELECTED
Regards,

Xiaoxin Sheng